When you define a date, it must be identified by a precise day (day, start of month, start of quarter...) to which you can add, or from which you can subtract, a period of time.

E.g. to set a date at the beginning of next month, you need to use the syntax "end of month + 1 day", i.e.: ENDOFMONTH+1D

  • To multiply a period (for example, a 2-month period), add the multiplication factor before the keyword of the period.

E.g.: 2M represents a two-month period.

  • To refer to a period in the past, add the minus sign before the keyword of the period.

E.g.: -2D refers to a period of minus two days.

Word Type Usage
D Period Day
W Period Week
T Period Ten days
F Period Fortnight
M Period Month
Q Period Quarter
STARTOFWEEK Date Start of Week
ENDOFWEEK Date End of Week
STARTOFDECADE Date Start of Decade
ENDOFDECADE Date End of Decade
STARTOFFORTNIGHT Date Start of Fortnight
ENDOFFORTNIGHT Date End of Fortnight
STARTOFMONTH Date Start of Month
ENDOFMONTH Date End of Month
STARTOFQUARTER Date Start of Quarter
ENDOFQUARTER Date End of Quarter
Sign Usage Example
+ Addition VENA+VENB
- Subtraction VENA-VENB
/ Division VENA/2
* Multiplication VENA*2
@ The At sign just before a budget code refers to the budget code in the Treasury Budget, and not in the Operational Budget. VENA@
% Percentage VENA*119,6%
( Opening bracket (VENA+VENB)/2
) Closing bracket (VENA+VENB)/2
: Separator between a variable and a distribution value (in a distribution function) ADISTR(IMDOCD;(ACHA:80%);(A196:20%))
; Separator between list elements (in a distribution function) ADISTR(IMDOCD;(ACHA:80%);(A196:20%))